insert overwrite table jms_dim.dim_order_source_mapping
select
  subscribe_source_code as ordersource_code
  ,subscribe_source_name as ordersource_name
from jms_ods.yl_oms_oms_waybill
where dt='{{ execution_date | cst_ds }}'
group by subscribe_source_code,subscribe_source_name
 distribute by 1 ;